Transfer Part List to XL (CB22)

 

Function	Transfer Part List to Excel based on Multiple Criteria
How To Use
Query Criteria	The Selection can be Based on the Following Manner
	1.     Type: Assembly or  Product Set.
	Assembly Indication a single Assembly qualified by Group/Set. Product Set Indicates the assemblies in the Product Set chosen .
	2.     Report Option : BOM or Combined BOM
	BOM printing the List of Parts One below the Other and Combined BOM prints the parts as a Matrix.
	3.   Rate Pick up : Normal or Normal + ED
	Normal signifies the Wt average Rate determined by Finance and Normal +ED signifies the Wt. Average rate + Excise Duty on it.
	4   Cutoff Month Specifies the corresponding  Period/Month for the rate
	5. Report Type : Summary , Part List , Issue List and Design
	Summary :  Considers all Parts and Assemblies in the BOM without Phantom Assembly
	Part List :  Considers only Parts and Not Assemblies
	Issue List:  Consider One Level Parts that will be issued
	Design:  Multi Level Part List
Combine BOM Output
BOM Output
Pre-Requisites	Assembly Part must have been registered using CB11, BM11 , and  Set must have been configured using CB21.
Notes